SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 710191 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 710191 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498831,302170,684048,489312,865570,290699,721632,798359,691018,836767,680537,775559,403065,947661,250601,524994,28994,149664,681509,369912,733138,577731,26697,250031,184059,701346,267833,374118,696270,887375,173337,858437,892019,81975,250055,1039619,262551,491852,818310,482450,34030,1025633,749249,718182,342709,704498,68843,631568,623360,26097,552242,652838,804626,401716,693560,139427,2813,658150,711357,426313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 710191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 710191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]