SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018225 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018225 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327764,156785,376247,1002719,929361,636419,448875,481157,880468,134619,621997,516108,854399,817077,571400,1026262,212112,498524,851476,522452,176622,1023469,863522,551183,995946,1034518,505253,305128,927507,625396,671975,151015,979640,653146,976940,91271,16740,98706,368072,726540,778668,640248,543355,972796,492765,496484,854839,162084,788885,594933,951873,611530,55275,464100,48297,899391,992270,1012426,1014056,979720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018225 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018225 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]