SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804728 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804728 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450396,99106,373396,74256,841711,330441,294674,772103,341716,983981,71011,282293,667902,986147,496152,982343,791975,635352,187831,606016,442059,752307,939952,777299,48876,101161,607864,258852,625700,22885,639609,668190,391818,762489,449017,609464,628193,310170,757540,893920,825473,223604,360790,474304,580699,258302,493625,491894,719469,897688,433407,978634,292852,746607,1043008,1005892,441815,371676,204606,713141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]