SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461980 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461980 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (688164,868267,684252,760172,651757,655707,595936,339749,442505,327122,196160,179669,791801,169500,301314,850136,91466,765878,1043088,827580,706818,528734,448344,960754,620839,26059,48994,1045147,432613,42739,649280,494819,325753,375333,183627,520143,63778,801853,277715,516263,784356,702254,477035,174182,238090,628978,256960,320780,744328,585623,558518,908865,916595,793873,230343,805130,697569,234431,706451,708011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]