SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 742001 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 742001 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006399,117361,356710,498546,294701,1013378,158306,536624,851412,445949,780203,298747,321383,858726,1003484,695508,637183,292219,987423,775223,33750,645281,917011,273432,503549,846547,222054,935008,629189,638352,439883,355928,537616,647440,729428,383987,176677,390355,846300,864986,81280,796752,158128,967976,551958,965433,37426,569808,170097,77258,334229,593857,607195,12370,566984,893376,866829,843328,929529,614694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 742001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 742001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]