SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68181 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68181 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49489,428006,325744,943375,589112,831166,993470,792352,435755,697114,320874,216110,784386,64663,29628,511389,247440,975120,145608,76807,832161,885456,138921,101470,167957,631395,677820,409579,421578,715198,24051,123427,88962,831206,649238,68601,664187,550638,745612,766470,891454,786593,660192,496654,727587,436657,500254,640443,120254,435722,6873,843349,256121,672146,886031,143423,854615,70645,326942,648937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]