SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516901 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516901 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517099,632504,703921,678258,544083,873805,719832,270034,175198,40115,278737,815197,905816,1036552,637751,749970,862511,79879,998014,944182,325316,40230,990563,302298,581166,107203,875949,664082,93791,660324,7251,701945,507020,660636,542754,1026350,572148,30921,257770,1044200,668624,385638,20150,569078,599548,31827,663264,214316,434066,541193,693028,161765,112040,698575,297353,784236,378686,763148,1038212,218074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]