SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000900s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001396 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001396 [ RunTime:0.004032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198393,711813,806822,361191,1047336,719246,197932,645989,581981,446347,6822,1015762,535536,323580,424852,848058,794806,950739,351955,59283,936812,375269,82250,945829,417124,208431,869259,46780,592603,435751,388493,888966,253488,417122,318171,353724,100881,859034,810710,107944,220321,212554,893017,244160,344819,607928,751672,693459,671064,16886,78469,793101,939066,36566,650071,142446,1027088,708553,715967,270840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]