SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685699 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685699 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56809,956917,889242,677348,72062,642089,87421,500482,345383,454568,451528,535554,490394,349079,40180,955170,833760,1038533,52320,990335,627892,856738,647569,556291,510101,110567,990826,563463,124693,310857,380526,278898,961657,406907,718500,26483,355305,607585,996284,223032,890978,842665,856137,387649,1020928,611114,715477,48708,196401,738953,764108,819860,860656,186777,210801,101316,653914,444143,214235,473279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]