SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508425 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508425 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917481,280922,996102,136922,133753,756886,661599,852334,576263,985449,116212,1034622,769160,19005,647572,660450,242814,729865,552421,541618,33739,68330,248667,364624,511623,1015068,169056,435700,5902,590509,443447,433180,605612,792973,856340,799046,406630,714069,487157,430578,789383,592093,899984,571795,660212,34436,508346,177909,873489,415328,975784,1012022,976882,812845,868168,111669,415368,247023,1014309,726180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]