SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349451 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349451 [ RunTime:0.002530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484131,18732,453861,395480,782679,979362,254390,952518,407920,773190,95090,679293,13621,450996,15208,431741,136200,129368,78477,150628,967831,153270,1020197,22155,872261,280859,232449,881190,922946,238791,754815,219691,831615,1013644,457524,191781,678988,117526,751356,472064,54609,315485,347719,954712,279745,994254,344845,123615,898563,329896,282725,85844,678975,955520,1026574,190943,905886,801414,162748,1024227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001766s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]