SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475743 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475743 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403326,940785,418157,416598,785556,525033,185747,818089,553806,972590,617914,647718,63157,685187,196188,162656,310835,1026784,368615,606231,590396,340842,151046,256553,779741,19799,759232,872933,357093,684239,849612,669074,847739,820587,510641,169789,540797,358823,5695,838379,515546,769481,244180,518620,604396,836387,557654,286126,928281,654583,616393,618629,259082,158917,665635,402348,770697,88703,776940,369152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]