SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001792s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 9718 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 9718 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271040,671014,869557,684933,976124,736120,111763,392436,490555,378652,288126,800604,472938,235792,600286,301739,307322,629581,797948,611582,668852,773966,454993,663154,1038531,100927,977026,384516,866874,814531,142465,455676,825468,181630,536219,830863,213250,332895,721721,992493,993475,559702,935415,874518,202746,861893,533991,247709,962753,811439,174080,124230,668975,329005,132705,294859,286822,180064,723650,131412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 9718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 9718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000741s ]