SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268443 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268443 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507145,394652,76917,599571,272457,673871,1016321,522545,143149,472005,701321,823847,813920,40728,562811,293298,818693,521111,998006,56858,509375,693242,266550,411503,614041,236700,584647,114152,449983,802899,1039961,883515,143173,562208,156518,921274,936933,1022861,896377,484715,353140,740681,1034253,404095,1045706,305213,881547,664864,941505,405385,982754,426582,687432,488086,722377,554735,718771,769852,159695,756061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]