SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033680 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033680 [ RunTime:0.003339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850050,139401,358496,11804,480815,207711,21418,379260,192792,1021723,984470,939406,577207,169387,304936,408263,201601,821106,472057,1037982,659941,190716,320688,272686,1005797,846569,237346,356798,42639,518973,99534,487731,218088,984450,727390,854567,818553,743441,58351,955419,263353,223502,921653,428360,489703,916872,810367,836141,233069,1040202,376846,389397,240692,263091,392983,417718,578318,842074,964856,323711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]