SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491011 LIMIT 1 [ RunTime:0.000565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491011 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235594,914420,458322,875602,940348,221695,274421,230308,811793,244758,439886,780932,637596,461147,261672,659837,351163,61204,36660,782007,138787,17645,840394,331716,630120,112250,581863,839289,721086,140760,310896,819284,311543,656522,365383,205840,793209,54057,227385,471775,624459,478134,656482,642786,1033840,171102,763145,896233,677679,211026,207353,88531,828199,754672,359526,505198,279824,561504,92955,108724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001212s ]