SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282003 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282003 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749892,693868,645175,556482,477435,320389,154075,719723,945677,141273,666126,864280,901506,508278,266417,769323,356768,628005,1041197,808830,435403,210804,967918,420216,489168,938142,214774,472415,1002060,323357,338142,118201,557480,495365,891359,1038413,214455,828488,192209,154558,438852,480477,944287,754858,484613,649218,627486,546377,1041100,152677,707856,721843,638435,271913,179903,268220,660439,935538,765322,154790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]