SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556618 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556618 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043741,39163,493568,765693,874777,15551,650321,997739,619997,59595,864098,1015779,145325,382147,865943,501737,297392,28349,167332,177005,294358,645185,111707,96772,922361,157319,760712,614690,317,126908,627672,348565,313203,929696,411056,609315,487252,873033,1009841,607135,97382,578502,466797,82247,539547,1035694,712153,861998,699753,48449,977206,702448,887262,436690,969180,191586,213631,1029218,558301,742592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001272s ]