SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4698 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4698 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328029,188719,434709,325950,280651,718222,262368,992260,943542,513676,117015,655200,730873,720826,582320,530436,750513,266068,71731,472191,380379,976761,525017,295136,761705,270200,860809,549535,194157,558345,912787,539070,601731,387677,593333,304558,846055,438421,221228,360364,570583,791051,12685,219229,166856,758114,941053,95718,222416,220759,258113,701105,995804,86834,971970,182388,371815,761369,156247,636066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002757s ]