SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368218 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368218 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263975,721006,97823,14330,564699,838606,588545,49910,832188,533839,981352,969172,677346,616313,656558,573163,992338,194732,127560,381526,304914,870140,525442,515124,7241,748593,452891,983510,721311,265046,297973,1031070,494020,899106,396350,40981,554548,485314,481948,5048,25813,77300,761653,927668,990244,214159,224459,1001606,292375,781128,13578,696674,962037,30767,361538,250113,833026,213528,768757,735191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]