SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339796 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339796 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561722,817113,637703,537189,503342,676645,366535,940893,1022214,418578,1046807,616997,294955,340787,870007,1000950,292093,823904,363167,172309,858929,893530,69481,107936,869889,998105,124950,341546,577753,104115,736165,714563,270779,145208,12390,133564,768112,18538,1025160,214182,1027716,685045,28912,190415,478377,423358,39954,359137,422057,692873,744570,609636,672110,273976,379156,1048458,249078,134799,377146,146326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]