SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004622s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534006 LIMIT 1 [ RunTime:0.000885s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534006 [ RunTime:0.002393s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55788,1048504,866366,1001360,1022319,145516,968600,300745,856508,853377,300565,918368,915452,645685,802413,235252,26976,496206,268901,244979,207808,254782,1026486,524008,38278,510274,137336,271208,94526,122605,906081,136391,375497,315160,714819,84367,167276,484284,602230,628181,1046246,87590,641541,515477,487844,228680,28787,543646,284706,158563,762211,821328,379633,1048192,923855,505094,142397,810656,338247,148479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000850s ]