SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504664 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504664 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49065,987013,629829,92879,435647,327173,830848,385578,36238,664476,601882,89769,158765,849591,120210,703051,900498,841761,670485,700362,224581,127307,189187,522633,221954,916024,473699,857773,881073,332549,706823,682731,541877,75356,994838,1032638,340097,429573,128321,495101,25113,778833,737962,1026725,767094,72888,920198,561147,237576,499454,168857,52444,129631,353516,69588,764499,419194,686079,604794,207996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504664 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504664 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]