SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019908 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019908 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183854,743622,194596,152004,176491,861600,551293,853635,414908,1010329,846511,36996,637059,127984,199030,410651,747021,773682,338848,1007358,660427,568345,490173,97888,710790,701460,221406,29154,746557,765166,345527,616111,908847,391598,169325,303229,446400,841819,999708,781251,641555,918184,616021,864789,248013,581,922264,854739,1009156,903531,910515,380640,470327,960716,588252,380628,311684,904798,294530,593611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]