SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046662 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046662 [ RunTime:0.005294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103662,641942,467926,132380,165715,409043,794348,910127,920210,336374,925453,577678,107066,550543,594535,608963,159625,359818,284145,205490,650288,208850,282297,69595,864607,117470,37878,159467,87141,275061,995269,757271,603542,857239,267102,398211,651422,553497,936694,528134,411149,534908,310522,336474,215418,1020192,917534,627389,407161,179257,336795,605513,92952,19265,405908,644409,609717,301723,539329,21090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046662 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046662 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]