SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510261 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510261 [ RunTime:0.003482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552307,980706,216113,281651,492022,1000038,305127,331640,354889,544897,79512,125094,1041753,318013,798400,174237,534197,980521,622908,395319,625759,295035,97287,225734,314527,579863,114043,1046422,1013324,365712,871705,462024,907804,187306,75923,126018,569281,650320,769028,217353,64107,226528,615871,708197,58098,769307,978593,543977,573478,916083,1032861,817820,915770,187164,762103,226130,812415,247014,315630,130532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]