SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320679 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320679 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269548,363190,569465,78173,736585,1028092,276400,521378,593019,819593,743996,898495,388065,931586,482278,384015,669950,1007814,285259,101779,50752,749052,145369,597426,172200,211856,428135,843615,99785,279003,223539,125479,158589,444638,689156,535071,340693,220607,846038,360168,426286,259699,559139,256187,105373,830243,289625,722230,381166,695106,410720,809180,57182,234998,916898,876511,233270,947260,584947,1048919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]