SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038320 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038320 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371041,892600,593470,671575,304487,412491,302748,542146,46490,97982,319807,816100,662316,437095,604738,342020,377603,730600,909153,301023,31589,747085,325532,580988,957952,258036,743607,986904,107945,27602,654727,176856,503436,512553,626774,666350,533704,49311,470115,616191,467835,509951,380921,16576,925851,580790,815011,623103,1041893,438296,134607,37165,592092,920662,1041076,880453,145999,664084,940502,526464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]