SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154434 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154434 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562875,462896,279535,176114,97859,273044,608739,786507,213701,487872,190987,803297,905566,101396,1043042,556706,42407,186577,117173,244988,850854,812652,864933,655523,475873,744812,686256,34094,402580,304931,485524,88035,327646,681803,624990,345791,16520,54192,103144,907847,1030224,645098,84149,406745,1018550,480179,187581,520300,888932,279457,387989,845781,645677,306892,660070,951212,716013,989224,990505,737712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000954s ]