SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018726 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018726 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81210,221077,475213,652097,749481,249227,354295,610010,130586,476240,807533,192812,348562,1028419,399397,18232,144430,1001840,269205,548422,887935,36192,219871,83841,925284,134317,515578,899455,526672,1002125,743115,287723,818573,848730,794635,832402,613470,529666,400262,741462,627091,648922,60620,568365,456709,482572,185002,200954,1037691,526675,951948,538762,43606,35942,109919,679013,444565,551587,211220,886213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]