SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004766s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514222 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514222 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816321,955869,320975,100139,292853,585669,446543,517554,522694,1026697,567382,562809,186732,866497,302740,774613,925904,767412,160504,815577,103052,679342,948084,748033,913453,17258,584450,320685,392810,238781,472293,809022,374048,253386,61400,73543,894997,175287,355458,961481,90238,229386,287717,422231,461033,227682,949659,425070,548290,983950,201973,745247,999303,137654,223745,76885,828286,209149,844633,2114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]