SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545052 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545052 [ RunTime:0.001456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337641,746069,406150,768620,1026193,611151,109790,946241,408090,145732,283975,323155,269075,351385,809273,268436,102582,970017,311909,277858,552070,772829,525057,725105,762978,88671,792060,469621,951031,494791,712212,165557,671933,27768,539229,160740,195023,661942,95272,28817,721790,475313,389063,862308,474418,518435,137961,395583,139298,519299,764770,110682,215230,382211,241401,346254,136852,67238,711672,630125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]