SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424731 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424731 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935214,309227,22733,162011,277753,239263,856050,325238,882031,777269,90919,963465,696451,900353,121333,264533,998420,371434,382945,250247,775330,540120,122414,469116,940778,686551,938873,271770,497239,733121,592286,273112,538827,728544,479686,288754,347829,31036,276848,44010,284590,61349,182916,31899,437198,367792,949767,913329,366874,140568,68703,137243,471461,119098,614177,645181,113948,89225,569136,624065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]