SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211188 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211188 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500544,777454,149955,270612,392857,831894,382680,311333,773671,155918,194700,450203,220318,856023,1045550,765036,16093,31842,959614,121988,941347,571008,524928,668102,439947,784253,804236,757981,838216,962963,396270,1027608,210836,320983,475085,400995,77582,329571,1024174,317866,977415,297229,826973,273981,673513,582524,725103,449059,934232,30429,1034687,33558,1000367,307868,369857,223625,111358,416613,572709,708310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]