SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402944 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402944 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490384,983590,1024146,585670,934246,992938,475385,611858,165239,56126,131056,927173,29786,813691,55803,965632,839415,337714,25878,782902,997157,569209,114893,728079,631999,923564,945523,15422,200675,295402,135580,515551,300138,484893,813627,653328,760362,508404,324662,99305,1034518,86879,21420,749912,860048,979542,842305,810713,212415,520248,882636,500427,515286,863732,108506,880989,532150,859925,1031308,379056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000803s ]