SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505941 LIMIT 1 [ RunTime:0.000553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505941 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144140,810546,440365,928915,993199,153558,856914,357653,266815,739932,651277,659774,1008915,204126,861725,201415,688670,187400,1031211,483089,47941,203871,902488,641925,3653,401910,524259,570142,617448,964210,921038,633484,166655,78232,910709,343493,258319,127824,474127,766735,411191,730809,103109,1025491,405,642312,828731,180844,162343,108447,354047,399763,56378,291440,106222,91595,299804,878621,584693,554223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]