SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54787 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54787 [ RunTime:0.003010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951324,558217,441419,314918,31209,943512,65516,500561,71473,4253,23172,801819,881791,66663,732896,639475,111637,823205,493472,553358,279628,1003670,27546,945216,686208,489236,793252,493841,663644,82810,477509,800929,92531,72764,597553,423257,3960,167137,671792,275835,17262,802435,181185,72554,265073,558311,820610,525298,563532,65772,165822,301505,1009810,317404,635967,391848,902556,982037,421317,860154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]