SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20510 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20510 [ RunTime:0.002514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233222,299056,562427,826567,265572,904132,731686,749871,482036,483850,999643,1011253,528940,263713,434220,419961,907144,261622,854798,952972,482741,423504,943462,981366,326462,921032,273656,81461,796800,442860,776564,630735,294748,964723,751998,759207,623481,161485,20857,1003994,477206,918073,847555,142158,807061,95561,1035031,859753,268440,794482,637365,793882,153210,182968,806954,979943,882780,139667,671701,808131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]