SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506166 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506166 [ RunTime:0.004456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140506,719343,719072,399791,360476,583075,214683,592858,326373,689653,459627,900913,471041,122479,386329,72130,757695,260553,125349,205834,788910,363301,795431,844158,853429,1008331,79650,15356,69614,847653,984701,540862,1042435,210000,109930,212,800498,409417,292575,54479,386426,894267,542776,7787,276967,482716,380792,134698,950947,79187,260445,578787,594478,806450,234262,647139,1013394,953521,5565,887003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506166 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506166 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]