SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 718834 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 718834 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500972,748044,53141,437592,101167,133098,920283,808211,200127,897379,168907,634242,10420,387256,514734,175314,276361,394361,851900,484902,551887,53770,79779,351449,1044590,873810,535000,527577,90736,536754,863423,59038,41681,304795,47481,837866,102550,404581,507291,968283,490904,757020,651050,332598,477987,744658,537477,863377,115410,8569,801241,813814,389158,319887,664156,613631,338740,370218,718053,158221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 718834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 718834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006886s ]