SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002002s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351340 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351340 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512718,91739,743352,997736,841885,51402,950072,750849,1047607,311500,159329,668499,210452,498406,573340,783874,44848,134069,143652,707144,239804,746775,147823,6418,31887,93527,391856,1013291,852144,666170,628182,630559,334950,655116,656535,33478,177664,1002408,62067,825764,125241,509040,703145,332885,941896,578782,577209,284458,991260,591651,187659,524798,384140,572218,131302,946996,217321,256201,329867,386552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001208s ]