SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54673 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54673 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448454,564570,683845,990017,720216,220305,427853,141773,277757,430659,375214,89058,647145,887338,404105,281075,584467,6492,1040506,910777,663793,340012,5897,262652,743712,768492,228632,690464,1034743,452971,19265,197806,618029,409618,707857,1801,582361,323404,39547,588777,325295,388819,905620,889214,553890,778826,969370,5227,209612,764579,854442,323812,358316,908702,589102,24181,133519,876300,215303,354051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]