SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343986 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343986 [ RunTime:0.005739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496895,493257,972882,416414,797016,602881,896640,594880,386460,745613,702303,556686,1036904,837677,412042,370315,915800,477866,468863,395126,608052,763896,108730,831497,8531,162768,768401,157574,5549,822204,289920,123681,379335,382212,185148,46886,711044,811770,875032,182803,373810,705466,156349,864681,13378,261236,199030,699312,1027403,863678,458362,757995,331465,289409,618872,49658,943254,857230,17999,935784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]