SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514807 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514807 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212211,887817,196038,735832,929754,562888,894059,419368,97063,415773,351407,886489,656611,829534,271182,315399,211313,889984,442337,322051,881632,882223,1019389,986155,761722,701625,69969,359928,58179,326703,799024,461772,179057,635708,976505,107180,445237,46965,622564,551273,601800,239956,64079,259768,895253,223584,1005633,667881,268616,779713,145380,756312,1001460,397944,208958,605010,285468,471687,1013327,6017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]