SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540939 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540939 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413359,1024125,795791,693062,385728,391635,183571,636252,928933,589617,526449,703153,396381,613650,513546,483171,417724,409357,33945,289054,599280,781066,373180,68833,959041,106558,375891,192594,766629,760768,576369,773202,245826,370465,925049,1020361,468148,191816,168925,162957,339465,108620,483215,63036,152725,385941,566346,208429,524127,1022944,772467,107213,754927,822264,57129,858172,340274,238974,862952,565891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]