SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021068 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021068 [ RunTime:0.002665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643941,948808,805608,492703,881445,154538,380987,712588,617370,301466,900421,338770,295935,158654,153950,669414,924143,631307,817022,678363,563538,4370,753001,995179,964658,1036659,50145,14683,495263,1021451,336126,481909,365388,280484,733294,614653,896175,388265,474392,600945,29600,21478,936302,806539,70497,294575,226336,594806,340119,504933,821149,210382,791239,748991,521430,31762,957170,157183,213327,745182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]