SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001837s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502848 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502848 [ RunTime:0.004822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261579,381611,129739,176887,106802,942437,708692,279811,740456,445499,911671,209920,550901,1040456,346240,268612,271079,1019872,962453,897576,831946,824014,483532,697914,140336,307609,671129,912694,826470,1025700,73338,583633,218681,745597,983714,683416,87584,161551,354932,786163,110076,766636,171270,998755,410082,373802,486377,773888,689325,186220,749760,739067,325844,1029448,91476,786517,140280,89578,477702,293665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000734s ]