SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3410 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3410 [ RunTime:0.005712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375914,914621,823969,998808,252073,712334,649910,194193,784130,327300,890991,553749,863534,899836,883963,4801,763180,54354,213852,896365,911389,475580,809203,34690,202957,902571,1044083,157923,814126,440600,109384,111303,529388,402395,111911,1013246,221009,812516,288587,1045729,717059,670400,186449,1016380,48323,275317,238091,140579,794956,691542,828052,291138,185317,973037,880715,686661,694828,727485,369515,724845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001181s ]