SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39310 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39310 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235415,72407,246625,191453,212098,824363,102692,801756,518281,979830,575605,765840,744284,731928,939513,82605,190594,872764,301669,822495,640688,481799,120653,539320,619671,699912,260508,566540,92884,910948,82646,384117,82637,790803,87184,483536,773621,439814,764045,1027595,655893,519999,976148,956766,393892,747033,196170,550745,3022,535716,546508,868380,97845,338828,201630,859743,169603,958760,151361,322374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]