SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311528 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311528 [ RunTime:0.002122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510245,409580,196121,2806,251714,494445,815281,805959,980904,208573,195994,405532,463684,381182,187637,60573,267060,692957,162143,799974,214367,416924,857675,17805,243198,165729,433200,888470,252665,70898,981693,132772,630989,101203,845679,608126,986374,332466,761206,703587,29477,966849,969366,597066,655642,905011,532078,388069,547833,604472,370679,701877,961997,428274,12334,176700,797112,924573,274299,138168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]