SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580301 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580301 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252960,123963,777738,473706,117745,534011,22561,488167,997754,143113,364459,299312,755448,448761,952715,969956,671952,174386,355181,247895,589405,88737,810103,537958,588436,437066,466424,808732,98077,134648,518023,815532,249775,15799,39511,409676,636501,245916,130455,466970,990404,198515,223401,1016129,937936,845141,587519,625655,842308,1009792,720815,257226,478903,36854,732176,659890,351863,433441,768539,882488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]