SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417578 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417578 [ RunTime:0.002540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750713,505306,939233,215113,685555,279433,612863,98514,197940,548746,471578,905589,846584,139604,858996,44399,886221,155802,847459,449159,338269,153372,661360,303857,852993,1027383,645640,654481,775270,1046936,883800,291362,362853,657305,604101,84487,859744,130669,525559,917385,797701,1021575,381491,275940,1039446,170873,534834,326509,307474,244494,513250,343207,600802,475578,920992,200155,484411,529171,281545,457458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001241s ]