SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421880 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421880 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273163,1020299,780726,1001130,184891,122453,90567,213633,618566,1275,1030025,754243,449526,927179,341752,504464,650746,719871,638430,1032964,820377,910110,983187,849987,1020529,253186,608675,401233,167043,767095,158577,940547,959491,862991,1033788,696190,404536,260902,55533,720906,491582,537078,936015,438175,173785,547725,194709,974059,819437,951873,1009805,481766,765698,474771,630724,515800,534418,960433,126328,529505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]