SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010535 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010535 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701491,1039491,104013,805970,546804,95046,911307,115950,871555,409716,967169,304994,737997,842478,28419,259120,659132,384758,565770,188675,839201,287440,649559,382772,338312,391806,599532,261475,796184,713174,975246,310350,202507,80709,830116,156716,555245,1028040,61762,756043,621078,326310,213002,761522,872795,550369,307545,803420,334503,755928,617688,405577,443197,151694,692938,1028589,704737,461233,101270,655418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000844s ]