SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53205 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53205 [ RunTime:0.004470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499834,563581,801118,842960,23179,183732,312482,396714,816948,575007,562090,302335,344950,971348,159999,593275,960482,241156,103276,618162,790879,449847,386396,862276,863890,311262,945925,373885,651354,695918,47277,433871,344048,241176,41530,79998,26725,349692,1007872,610494,481438,726522,596514,71048,93632,335794,417078,8136,257047,944941,1018963,209752,137321,863549,545211,479480,365457,352707,351339,8268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]