SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 248915 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 248915 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038122,628635,11646,1027987,403928,163082,282562,295992,332499,373760,244385,847701,383754,218775,392267,729353,113454,880359,346370,183700,217796,762725,774775,597632,543048,845338,501959,196321,952136,304418,687552,928083,135026,471131,839289,951868,354122,539890,470398,224222,925981,302460,266046,853459,961063,793865,965897,197021,612146,658079,241105,172323,821320,636740,84154,423526,742498,204591,667018,189445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 248915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 248915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]