SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485005 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485005 [ RunTime:0.004415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119357,623615,76027,142277,292890,609214,66050,314308,944689,496552,257868,693177,888436,547268,693489,713768,829193,1010782,575737,15916,368800,296160,525959,608676,859556,513844,975543,164902,1016079,769094,262683,243215,777993,298210,618877,435012,644590,681643,693418,197663,881438,994236,797860,527656,406754,281995,892675,730030,125836,667065,417038,893626,507355,236552,807918,168294,24660,39794,1018942,708413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]