SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204490 LIMIT 1 [ RunTime:0.000753s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204490 [ RunTime:0.002037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465512,131576,655635,1030587,1012011,405143,183318,84210,699758,272252,619622,624781,850935,199097,341405,541429,79909,49106,311361,414384,699754,687204,89015,509817,87713,950493,413854,439315,621595,187424,64637,740932,796069,270965,203507,421687,169408,778486,337192,744893,303966,626714,463510,106608,722307,6456,579972,42522,844616,597118,489573,1032606,998753,188687,486253,180199,649537,198364,998345,74451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001520s ]