SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262051 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262051 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100745,582476,215548,387827,36142,485161,9499,112850,943998,900654,888249,688392,211167,253904,887952,678428,861841,788430,731955,227265,107706,175669,671765,224505,60569,161445,409124,52890,6635,143287,853439,47689,1041037,19008,329441,157037,834899,917127,903285,1030082,31066,225235,272374,27765,820696,255714,80546,833161,82648,732272,604176,696849,717242,453778,189858,330900,735014,210889,574653,985421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]