SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53551 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53551 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396311,79979,975969,134713,815775,88578,629392,1005103,221569,242068,326345,800445,415289,738865,17007,832455,918499,118656,235066,296632,435779,545442,897362,553436,215205,983144,619375,883222,791577,493540,703724,1017506,400095,811367,510565,371998,674395,439324,855817,597547,275919,104753,544074,60849,430675,899889,729711,115573,998111,125145,280148,925595,541943,881728,725202,204179,111387,431084,1042635,263130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]