SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118280 LIMIT 1 [ RunTime:0.001462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118280 [ RunTime:0.002588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710219,602915,797196,94558,959928,530783,883425,915094,489144,477535,523659,35129,815758,98555,571819,998809,866710,228992,396069,881375,553979,497989,444469,964557,10311,332479,548681,488097,438094,443371,925044,912600,945078,811873,208444,412480,114350,748123,976848,658588,390617,741357,372144,547518,423166,221752,1011899,938697,231754,634064,694293,117255,963146,452092,343378,158048,925475,611584,757093,3137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]