SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254808 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254808 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861559,220299,475003,828148,946317,661413,958142,162737,195623,382573,605958,199925,898711,707430,78745,196372,392962,988129,102366,686964,77944,426550,529843,349377,55737,835800,359329,767888,1348,761220,157851,794466,671629,597812,25519,141016,186489,844516,415044,358090,470489,894387,291451,118813,284865,825286,12350,395738,390278,39422,77289,743742,353525,711997,708849,900703,61067,566191,623117,723924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]