SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480353 LIMIT 1 [ RunTime:0.001177s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480353 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637942,225882,708624,353152,969800,844831,191006,558902,414753,329362,140751,791160,835642,303619,57734,535438,74888,497852,1000231,438337,1037568,205275,924559,328100,935896,423639,973781,369197,798039,681319,410910,77870,619101,952823,988163,325382,761276,851317,310687,1034887,55902,240967,449414,120875,50748,112899,125814,792315,82280,458338,777308,883877,237266,1012164,206087,150851,110452,848590,126479,76625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480353 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480353 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]