SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920329 LIMIT 1 [ RunTime:0.000711s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920329 [ RunTime:0.002307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628516,404197,173891,472834,340031,109284,448830,464570,601437,139828,600150,371120,650382,916447,854603,318996,364729,797192,497138,487927,570711,823725,782166,584170,945363,633924,641843,519957,511406,614739,347012,175395,130125,213802,886081,609455,247728,230754,979766,200087,641901,200942,16550,130967,765942,693777,587363,944997,696724,380342,514162,1010526,164917,58550,977095,111333,453552,114172,589783,397421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]