SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001436s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 92012 LIMIT 1 [ RunTime:0.000748s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 92012 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576619,427949,623925,344895,123540,198069,491966,633646,313262,506718,540070,288094,909043,793096,284214,188417,971047,697801,345702,1012980,1015111,88779,486663,882550,576484,793399,880663,319076,76257,1009122,169451,802713,769093,490659,371743,405185,58916,465526,110519,1017270,521037,108998,599255,541522,302286,309466,257403,773472,703064,753116,399354,660474,24846,903757,800106,95876,419621,757966,814004,884652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 92012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 92012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]