SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520410 LIMIT 1 [ RunTime:0.000655s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520410 [ RunTime:0.002594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29014,462972,622393,116513,772300,541498,335460,604757,57375,433834,974869,411982,349196,680565,82779,785512,488177,460456,26499,855881,944772,490663,815356,414024,800831,231166,744838,202344,642949,535720,931941,972501,787495,1042793,919440,499438,403238,965239,568084,863481,8621,898912,376030,298241,14504,500579,554005,28443,171120,812315,759960,335448,372409,395339,837979,701083,251578,345477,822233,834120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001421s ]