SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473440 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473440 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295580,160854,650920,638749,296689,970059,994553,407936,598903,857852,624337,102500,985155,177437,9630,677752,597270,163731,983114,552787,703576,642831,33225,17783,754958,445448,837894,636912,152041,587358,871909,590517,1045434,210984,597019,906805,817704,432490,602476,437755,726254,895673,853766,772793,361165,6451,238010,480220,814227,1070,1036712,496649,701946,77418,901303,250805,370567,348661,527712,649567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]